package com.hawthorn.redis.repository.provider;

import org.apache.ibatis.builder.annotation.ProviderMethodResolver;

/**
 * <p>todo 用户缓存sql类</p>
 * @author: andyten@tom.com | xukaixing@hotmail.com
 * @created: 2021/11/11 8:39 PM
 * @version v1.0.1
 * @copyright: Copyright (c)  andyten
 */
public class UserCacheSqlProvider implements ProviderMethodResolver
{
  public static String selectUser()
  {
    String sql = "select " +
        "u.id, " +
        "u.account, " +
        "u.password, " +
        "u.salt, " +
        "u.user_name, " +
        "u.sex, " +
        "u.dept_id, " +
        "u.user_type, " +
        "u.user_secret, " +
        "u.id_card, " +
        "u.mobile, " +
        "u.biz_type, " +
        "u.id user_id, " +
        "u.user_level, " +
        "u.menu_layout, " +
        "u.display_type, " +
        "u.display_col, " +
        "u.theme_type, " +
        "u.float_type, " +
        "u.alert_type, " +
        "u.status, " +
        "u.ex_field1, " +
        "u.ex_field2, " +
        "u.ex_field3, " +
        "d.dcode, " +
        "d.company_id, " +
        "d.oem_company_id, " +
        "d.pid, " +
        "d.biz_type " +
        "from sys_user u,sys_dept d " +
        "where u.del_flag = 0 and u.dept_id = d.id ";
    // "and u.status = '" + DicConstant.YXBS_01 + "' " +
    // "and d.status = '" + DicConstant.YXBS_01 + "' ";

    return sql;
  }
}
